package com.cn.mapper.dao.db5.PartsManagement;

import com.cn.bean.pojo.lbj.ParameterItemTable;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface ParameterItemTableDao {
    List<ParameterItemTable> selectParameterItemTable(ParameterItemTable parameterItemTable);
    List<ParameterItemTable> selectAll();
    Integer getParameterItemTableAutoid();
    int addParameterItemTable(@Param("ID") int ID,@Param("itemCode")String itemCode,@Param("itemName")String itemName, @Param("valueRangeType")String valueRangeType,@Param("sourceMethod")String sourceMethod, @Param("sourceTable")String sourceTable,@Param("sourcePrimaryKeyField")String sourcePrimaryKeyField,@Param("standardValueField")String standardValueField,@Param("lowerLimitField")String lowerLimitField,@Param("upperLimitField")String upperLimitField,@Param("description")String description,@Param("entryTimePoint")String entryTimePoint,@Param("isdel")int isdel,@Param("classificationId")int classificationId);
    int delParameterItemTable(@Param("id") int id);
    int delParameterItemTableStatus(@Param("id") int id);
    int updateParameterItemTable(@Param("id") int ID,@Param("itemCode")String itemCode,@Param("itemName")String itemName, @Param("valueRangeType")String valueRangeType,@Param("sourceMethod")String sourceMethod, @Param("sourceTable")String sourceTable,@Param("sourcePrimaryKeyField")String sourcePrimaryKeyField,@Param("standardValueField")String standardValueField,@Param("lowerLimitField")String lowerLimitField,@Param("upperLimitField")String upperLimitField,@Param("description")String description,@Param("entryTimePoint")String entryTimePoint,@Param("isdel")int isdel,@Param("classificationId")int classificationId);
}
